package com.edu.mapper;

import com.edu.bean.Employee;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface EmployeeMapper {
    List<Employee> selectEmpByDepartId(int departId);

    Employee selectEmpById(int empId);

    List<Employee> selectiveEmp(Employee employee);

    Employee selectEmpByDeptId(int deptId);
    
    int batchUpdateStatus(@Param("ids") List<Integer> ids, @Param("status") Integer status);

    int calcSumEmp(int deptId);

    double calcAvgSalary(int deptId);

    int updateEmployeeSelective(Employee employee);
}
